package com.fc.v2.model.auto;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import cn.hutool.core.util.StrUtil;

/**
 * 待检测列表 ScaletabExample
 * @author cjh_自动生成
 * @date 2025-01-30 12:29:49
 */
public class ScaletabExample {

    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ScaletabExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }
        
		
        public Criteria andDeidIsNull() {
            addCriterion("deid is null");
            return (Criteria) this;
        }

        public Criteria andDeidIsNotNull() {
            addCriterion("deid is not null");
            return (Criteria) this;
        }

        public Criteria andDeidEqualTo(String value) {
            addCriterion("deid =", value, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidNotEqualTo(String value) {
            addCriterion("deid <>", value, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidGreaterThan(String value) {
            addCriterion("deid >", value, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidGreaterThanOrEqualTo(String value) {
            addCriterion("deid >=", value, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidLessThan(String value) {
            addCriterion("deid <", value, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidLessThanOrEqualTo(String value) {
            addCriterion("deid <=", value, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidLike(String value) {
            addCriterion("deid like", value, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidNotLike(String value) {
            addCriterion("deid not like", value, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidIn(List<String> values) {
            addCriterion("deid in", values, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidNotIn(List<String> values) {
            addCriterion("deid not in", values, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidBetween(String value1, String value2) {
            addCriterion("deid between", value1, value2, "deid");
            return (Criteria) this;
        }

        public Criteria andDeidNotBetween(String value1, String value2) {
            addCriterion("deid not between", value1, value2, "deid");
            return (Criteria) this;
        }
        
		
        public Criteria andNominalMassIsNull() {
            addCriterion("nominal_mass is null");
            return (Criteria) this;
        }

        public Criteria andNominalMassIsNotNull() {
            addCriterion("nominal_mass is not null");
            return (Criteria) this;
        }

        public Criteria andNominalMassEqualTo(String value) {
            addCriterion("nominal_mass =", value, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassNotEqualTo(String value) {
            addCriterion("nominal_mass <>", value, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassGreaterThan(String value) {
            addCriterion("nominal_mass >", value, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassGreaterThanOrEqualTo(String value) {
            addCriterion("nominal_mass >=", value, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassLessThan(String value) {
            addCriterion("nominal_mass <", value, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassLessThanOrEqualTo(String value) {
            addCriterion("nominal_mass <=", value, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassLike(String value) {
            addCriterion("nominal_mass like", value, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassNotLike(String value) {
            addCriterion("nominal_mass not like", value, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassIn(List<String> values) {
            addCriterion("nominal_mass in", values, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassNotIn(List<String> values) {
            addCriterion("nominal_mass not in", values, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassBetween(String value1, String value2) {
            addCriterion("nominal_mass between", value1, value2, "nominalMass");
            return (Criteria) this;
        }

        public Criteria andNominalMassNotBetween(String value1, String value2) {
            addCriterion("nominal_mass not between", value1, value2, "nominalMass");
            return (Criteria) this;
        }
        
		
        public Criteria andMpeIsNull() {
            addCriterion("mpe is null");
            return (Criteria) this;
        }

        public Criteria andMpeIsNotNull() {
            addCriterion("mpe is not null");
            return (Criteria) this;
        }

        public Criteria andMpeEqualTo(String value) {
            addCriterion("mpe =", value, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeNotEqualTo(String value) {
            addCriterion("mpe <>", value, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeGreaterThan(String value) {
            addCriterion("mpe >", value, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeGreaterThanOrEqualTo(String value) {
            addCriterion("mpe >=", value, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeLessThan(String value) {
            addCriterion("mpe <", value, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeLessThanOrEqualTo(String value) {
            addCriterion("mpe <=", value, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeLike(String value) {
            addCriterion("mpe like", value, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeNotLike(String value) {
            addCriterion("mpe not like", value, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeIn(List<String> values) {
            addCriterion("mpe in", values, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeNotIn(List<String> values) {
            addCriterion("mpe not in", values, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeBetween(String value1, String value2) {
            addCriterion("mpe between", value1, value2, "mpe");
            return (Criteria) this;
        }

        public Criteria andMpeNotBetween(String value1, String value2) {
            addCriterion("mpe not between", value1, value2, "mpe");
            return (Criteria) this;
        }
        
		
        public Criteria andRead1IsNull() {
            addCriterion("read1 is null");
            return (Criteria) this;
        }

        public Criteria andRead1IsNotNull() {
            addCriterion("read1 is not null");
            return (Criteria) this;
        }

        public Criteria andRead1EqualTo(String value) {
            addCriterion("read1 =", value, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1NotEqualTo(String value) {
            addCriterion("read1 <>", value, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1GreaterThan(String value) {
            addCriterion("read1 >", value, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1GreaterThanOrEqualTo(String value) {
            addCriterion("read1 >=", value, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1LessThan(String value) {
            addCriterion("read1 <", value, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1LessThanOrEqualTo(String value) {
            addCriterion("read1 <=", value, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1Like(String value) {
            addCriterion("read1 like", value, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1NotLike(String value) {
            addCriterion("read1 not like", value, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1In(List<String> values) {
            addCriterion("read1 in", values, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1NotIn(List<String> values) {
            addCriterion("read1 not in", values, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1Between(String value1, String value2) {
            addCriterion("read1 between", value1, value2, "read1");
            return (Criteria) this;
        }

        public Criteria andRead1NotBetween(String value1, String value2) {
            addCriterion("read1 not between", value1, value2, "read1");
            return (Criteria) this;
        }
        
		
        public Criteria andRead2IsNull() {
            addCriterion("read2 is null");
            return (Criteria) this;
        }

        public Criteria andRead2IsNotNull() {
            addCriterion("read2 is not null");
            return (Criteria) this;
        }

        public Criteria andRead2EqualTo(String value) {
            addCriterion("read2 =", value, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2NotEqualTo(String value) {
            addCriterion("read2 <>", value, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2GreaterThan(String value) {
            addCriterion("read2 >", value, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2GreaterThanOrEqualTo(String value) {
            addCriterion("read2 >=", value, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2LessThan(String value) {
            addCriterion("read2 <", value, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2LessThanOrEqualTo(String value) {
            addCriterion("read2 <=", value, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2Like(String value) {
            addCriterion("read2 like", value, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2NotLike(String value) {
            addCriterion("read2 not like", value, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2In(List<String> values) {
            addCriterion("read2 in", values, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2NotIn(List<String> values) {
            addCriterion("read2 not in", values, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2Between(String value1, String value2) {
            addCriterion("read2 between", value1, value2, "read2");
            return (Criteria) this;
        }

        public Criteria andRead2NotBetween(String value1, String value2) {
            addCriterion("read2 not between", value1, value2, "read2");
            return (Criteria) this;
        }
        
		
        public Criteria andEqPositionIsNull() {
            addCriterion("eq_position is null");
            return (Criteria) this;
        }

        public Criteria andEqPositionIsNotNull() {
            addCriterion("eq_position is not null");
            return (Criteria) this;
        }

        public Criteria andEqPositionEqualTo(String value) {
            addCriterion("eq_position =", value, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionNotEqualTo(String value) {
            addCriterion("eq_position <>", value, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionGreaterThan(String value) {
            addCriterion("eq_position >", value, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionGreaterThanOrEqualTo(String value) {
            addCriterion("eq_position >=", value, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionLessThan(String value) {
            addCriterion("eq_position <", value, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionLessThanOrEqualTo(String value) {
            addCriterion("eq_position <=", value, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionLike(String value) {
            addCriterion("eq_position like", value, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionNotLike(String value) {
            addCriterion("eq_position not like", value, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionIn(List<String> values) {
            addCriterion("eq_position in", values, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionNotIn(List<String> values) {
            addCriterion("eq_position not in", values, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionBetween(String value1, String value2) {
            addCriterion("eq_position between", value1, value2, "eqPosition");
            return (Criteria) this;
        }

        public Criteria andEqPositionNotBetween(String value1, String value2) {
            addCriterion("eq_position not between", value1, value2, "eqPosition");
            return (Criteria) this;
        }
        
		
        public Criteria andDivisionIsNull() {
            addCriterion("division is null");
            return (Criteria) this;
        }

        public Criteria andDivisionIsNotNull() {
            addCriterion("division is not null");
            return (Criteria) this;
        }

        public Criteria andDivisionEqualTo(String value) {
            addCriterion("division =", value, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionNotEqualTo(String value) {
            addCriterion("division <>", value, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionGreaterThan(String value) {
            addCriterion("division >", value, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionGreaterThanOrEqualTo(String value) {
            addCriterion("division >=", value, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionLessThan(String value) {
            addCriterion("division <", value, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionLessThanOrEqualTo(String value) {
            addCriterion("division <=", value, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionLike(String value) {
            addCriterion("division like", value, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionNotLike(String value) {
            addCriterion("division not like", value, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionIn(List<String> values) {
            addCriterion("division in", values, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionNotIn(List<String> values) {
            addCriterion("division not in", values, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionBetween(String value1, String value2) {
            addCriterion("division between", value1, value2, "division");
            return (Criteria) this;
        }

        public Criteria andDivisionNotBetween(String value1, String value2) {
            addCriterion("division not between", value1, value2, "division");
            return (Criteria) this;
        }
        
		
        public Criteria andDifferMassIsNull() {
            addCriterion("differ_mass is null");
            return (Criteria) this;
        }

        public Criteria andDifferMassIsNotNull() {
            addCriterion("differ_mass is not null");
            return (Criteria) this;
        }

        public Criteria andDifferMassEqualTo(String value) {
            addCriterion("differ_mass =", value, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassNotEqualTo(String value) {
            addCriterion("differ_mass <>", value, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassGreaterThan(String value) {
            addCriterion("differ_mass >", value, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassGreaterThanOrEqualTo(String value) {
            addCriterion("differ_mass >=", value, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassLessThan(String value) {
            addCriterion("differ_mass <", value, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassLessThanOrEqualTo(String value) {
            addCriterion("differ_mass <=", value, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassLike(String value) {
            addCriterion("differ_mass like", value, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassNotLike(String value) {
            addCriterion("differ_mass not like", value, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassIn(List<String> values) {
            addCriterion("differ_mass in", values, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassNotIn(List<String> values) {
            addCriterion("differ_mass not in", values, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassBetween(String value1, String value2) {
            addCriterion("differ_mass between", value1, value2, "differMass");
            return (Criteria) this;
        }

        public Criteria andDifferMassNotBetween(String value1, String value2) {
            addCriterion("differ_mass not between", value1, value2, "differMass");
            return (Criteria) this;
        }
        
		
        public Criteria andStandardWeightCorrectedIsNull() {
            addCriterion("standard_weight_corrected is null");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedIsNotNull() {
            addCriterion("standard_weight_corrected is not null");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedEqualTo(String value) {
            addCriterion("standard_weight_corrected =", value, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedNotEqualTo(String value) {
            addCriterion("standard_weight_corrected <>", value, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedGreaterThan(String value) {
            addCriterion("standard_weight_corrected >", value, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedGreaterThanOrEqualTo(String value) {
            addCriterion("standard_weight_corrected >=", value, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedLessThan(String value) {
            addCriterion("standard_weight_corrected <", value, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedLessThanOrEqualTo(String value) {
            addCriterion("standard_weight_corrected <=", value, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedLike(String value) {
            addCriterion("standard_weight_corrected like", value, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedNotLike(String value) {
            addCriterion("standard_weight_corrected not like", value, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedIn(List<String> values) {
            addCriterion("standard_weight_corrected in", values, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedNotIn(List<String> values) {
            addCriterion("standard_weight_corrected not in", values, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedBetween(String value1, String value2) {
            addCriterion("standard_weight_corrected between", value1, value2, "standardWeightCorrected");
            return (Criteria) this;
        }

        public Criteria andStandardWeightCorrectedNotBetween(String value1, String value2) {
            addCriterion("standard_weight_corrected not between", value1, value2, "standardWeightCorrected");
            return (Criteria) this;
        }
        
		
        public Criteria andAirCorrectedIsNull() {
            addCriterion("air_corrected is null");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedIsNotNull() {
            addCriterion("air_corrected is not null");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedEqualTo(String value) {
            addCriterion("air_corrected =", value, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedNotEqualTo(String value) {
            addCriterion("air_corrected <>", value, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedGreaterThan(String value) {
            addCriterion("air_corrected >", value, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedGreaterThanOrEqualTo(String value) {
            addCriterion("air_corrected >=", value, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedLessThan(String value) {
            addCriterion("air_corrected <", value, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedLessThanOrEqualTo(String value) {
            addCriterion("air_corrected <=", value, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedLike(String value) {
            addCriterion("air_corrected like", value, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedNotLike(String value) {
            addCriterion("air_corrected not like", value, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedIn(List<String> values) {
            addCriterion("air_corrected in", values, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedNotIn(List<String> values) {
            addCriterion("air_corrected not in", values, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedBetween(String value1, String value2) {
            addCriterion("air_corrected between", value1, value2, "airCorrected");
            return (Criteria) this;
        }

        public Criteria andAirCorrectedNotBetween(String value1, String value2) {
            addCriterion("air_corrected not between", value1, value2, "airCorrected");
            return (Criteria) this;
        }
        
		
        public Criteria andMassCorrectedIsNull() {
            addCriterion("mass_corrected is null");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedIsNotNull() {
            addCriterion("mass_corrected is not null");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedEqualTo(String value) {
            addCriterion("mass_corrected =", value, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedNotEqualTo(String value) {
            addCriterion("mass_corrected <>", value, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedGreaterThan(String value) {
            addCriterion("mass_corrected >", value, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedGreaterThanOrEqualTo(String value) {
            addCriterion("mass_corrected >=", value, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedLessThan(String value) {
            addCriterion("mass_corrected <", value, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedLessThanOrEqualTo(String value) {
            addCriterion("mass_corrected <=", value, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedLike(String value) {
            addCriterion("mass_corrected like", value, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedNotLike(String value) {
            addCriterion("mass_corrected not like", value, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedIn(List<String> values) {
            addCriterion("mass_corrected in", values, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedNotIn(List<String> values) {
            addCriterion("mass_corrected not in", values, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedBetween(String value1, String value2) {
            addCriterion("mass_corrected between", value1, value2, "massCorrected");
            return (Criteria) this;
        }

        public Criteria andMassCorrectedNotBetween(String value1, String value2) {
            addCriterion("mass_corrected not between", value1, value2, "massCorrected");
            return (Criteria) this;
        }
        
		
        public Criteria andMassToleranceIsNull() {
            addCriterion("mass_tolerance is null");
            return (Criteria) this;
        }

        public Criteria andMassToleranceIsNotNull() {
            addCriterion("mass_tolerance is not null");
            return (Criteria) this;
        }

        public Criteria andMassToleranceEqualTo(String value) {
            addCriterion("mass_tolerance =", value, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceNotEqualTo(String value) {
            addCriterion("mass_tolerance <>", value, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceGreaterThan(String value) {
            addCriterion("mass_tolerance >", value, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceGreaterThanOrEqualTo(String value) {
            addCriterion("mass_tolerance >=", value, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceLessThan(String value) {
            addCriterion("mass_tolerance <", value, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceLessThanOrEqualTo(String value) {
            addCriterion("mass_tolerance <=", value, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceLike(String value) {
            addCriterion("mass_tolerance like", value, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceNotLike(String value) {
            addCriterion("mass_tolerance not like", value, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceIn(List<String> values) {
            addCriterion("mass_tolerance in", values, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceNotIn(List<String> values) {
            addCriterion("mass_tolerance not in", values, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceBetween(String value1, String value2) {
            addCriterion("mass_tolerance between", value1, value2, "massTolerance");
            return (Criteria) this;
        }

        public Criteria andMassToleranceNotBetween(String value1, String value2) {
            addCriterion("mass_tolerance not between", value1, value2, "massTolerance");
            return (Criteria) this;
        }
        
		
        public Criteria andMagneticReadsIsNull() {
            addCriterion("magnetic_reads is null");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsIsNotNull() {
            addCriterion("magnetic_reads is not null");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsEqualTo(String value) {
            addCriterion("magnetic_reads =", value, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsNotEqualTo(String value) {
            addCriterion("magnetic_reads <>", value, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsGreaterThan(String value) {
            addCriterion("magnetic_reads >", value, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsGreaterThanOrEqualTo(String value) {
            addCriterion("magnetic_reads >=", value, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsLessThan(String value) {
            addCriterion("magnetic_reads <", value, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsLessThanOrEqualTo(String value) {
            addCriterion("magnetic_reads <=", value, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsLike(String value) {
            addCriterion("magnetic_reads like", value, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsNotLike(String value) {
            addCriterion("magnetic_reads not like", value, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsIn(List<String> values) {
            addCriterion("magnetic_reads in", values, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsNotIn(List<String> values) {
            addCriterion("magnetic_reads not in", values, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsBetween(String value1, String value2) {
            addCriterion("magnetic_reads between", value1, value2, "magneticReads");
            return (Criteria) this;
        }

        public Criteria andMagneticReadsNotBetween(String value1, String value2) {
            addCriterion("magnetic_reads not between", value1, value2, "magneticReads");
            return (Criteria) this;
        }
        
		
        public Criteria andMagneticToleranceIsNull() {
            addCriterion("magnetic_tolerance is null");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceIsNotNull() {
            addCriterion("magnetic_tolerance is not null");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceEqualTo(String value) {
            addCriterion("magnetic_tolerance =", value, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceNotEqualTo(String value) {
            addCriterion("magnetic_tolerance <>", value, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceGreaterThan(String value) {
            addCriterion("magnetic_tolerance >", value, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceGreaterThanOrEqualTo(String value) {
            addCriterion("magnetic_tolerance >=", value, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceLessThan(String value) {
            addCriterion("magnetic_tolerance <", value, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceLessThanOrEqualTo(String value) {
            addCriterion("magnetic_tolerance <=", value, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceLike(String value) {
            addCriterion("magnetic_tolerance like", value, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceNotLike(String value) {
            addCriterion("magnetic_tolerance not like", value, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceIn(List<String> values) {
            addCriterion("magnetic_tolerance in", values, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceNotIn(List<String> values) {
            addCriterion("magnetic_tolerance not in", values, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceBetween(String value1, String value2) {
            addCriterion("magnetic_tolerance between", value1, value2, "magneticTolerance");
            return (Criteria) this;
        }

        public Criteria andMagneticToleranceNotBetween(String value1, String value2) {
            addCriterion("magnetic_tolerance not between", value1, value2, "magneticTolerance");
            return (Criteria) this;
        }
        
		
        public Criteria andPolarizationReadsIsNull() {
            addCriterion("polarization_reads is null");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsIsNotNull() {
            addCriterion("polarization_reads is not null");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsEqualTo(String value) {
            addCriterion("polarization_reads =", value, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsNotEqualTo(String value) {
            addCriterion("polarization_reads <>", value, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsGreaterThan(String value) {
            addCriterion("polarization_reads >", value, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsGreaterThanOrEqualTo(String value) {
            addCriterion("polarization_reads >=", value, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsLessThan(String value) {
            addCriterion("polarization_reads <", value, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsLessThanOrEqualTo(String value) {
            addCriterion("polarization_reads <=", value, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsLike(String value) {
            addCriterion("polarization_reads like", value, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsNotLike(String value) {
            addCriterion("polarization_reads not like", value, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsIn(List<String> values) {
            addCriterion("polarization_reads in", values, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsNotIn(List<String> values) {
            addCriterion("polarization_reads not in", values, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsBetween(String value1, String value2) {
            addCriterion("polarization_reads between", value1, value2, "polarizationReads");
            return (Criteria) this;
        }

        public Criteria andPolarizationReadsNotBetween(String value1, String value2) {
            addCriterion("polarization_reads not between", value1, value2, "polarizationReads");
            return (Criteria) this;
        }
        
		
        public Criteria andPolarizationToleranceIsNull() {
            addCriterion("polarization_tolerance is null");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceIsNotNull() {
            addCriterion("polarization_tolerance is not null");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceEqualTo(String value) {
            addCriterion("polarization_tolerance =", value, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceNotEqualTo(String value) {
            addCriterion("polarization_tolerance <>", value, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceGreaterThan(String value) {
            addCriterion("polarization_tolerance >", value, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceGreaterThanOrEqualTo(String value) {
            addCriterion("polarization_tolerance >=", value, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceLessThan(String value) {
            addCriterion("polarization_tolerance <", value, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceLessThanOrEqualTo(String value) {
            addCriterion("polarization_tolerance <=", value, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceLike(String value) {
            addCriterion("polarization_tolerance like", value, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceNotLike(String value) {
            addCriterion("polarization_tolerance not like", value, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceIn(List<String> values) {
            addCriterion("polarization_tolerance in", values, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceNotIn(List<String> values) {
            addCriterion("polarization_tolerance not in", values, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceBetween(String value1, String value2) {
            addCriterion("polarization_tolerance between", value1, value2, "polarizationTolerance");
            return (Criteria) this;
        }

        public Criteria andPolarizationToleranceNotBetween(String value1, String value2) {
            addCriterion("polarization_tolerance not between", value1, value2, "polarizationTolerance");
            return (Criteria) this;
        }
        
	
		 public Criteria andLikeQuery(Scaletab record) {
		 	List<String> list= new ArrayList<String>();
		 	List<String> list2= new ArrayList<String>();
        	StringBuffer buffer=new StringBuffer();
			if(record.getDeid()!=null&&StrUtil.isNotEmpty(record.getDeid().toString())) {
    			 list.add("ifnull(deid,'')");
    		}
			if(record.getNominalMass()!=null&&StrUtil.isNotEmpty(record.getNominalMass().toString())) {
    			 list.add("ifnull(nominal_mass,'')");
    		}
			if(record.getMpe()!=null&&StrUtil.isNotEmpty(record.getMpe().toString())) {
    			 list.add("ifnull(mpe,'')");
    		}
			if(record.getRead1()!=null&&StrUtil.isNotEmpty(record.getRead1().toString())) {
    			 list.add("ifnull(read1,'')");
    		}
			if(record.getRead2()!=null&&StrUtil.isNotEmpty(record.getRead2().toString())) {
    			 list.add("ifnull(read2,'')");
    		}
			if(record.getEqPosition()!=null&&StrUtil.isNotEmpty(record.getEqPosition().toString())) {
    			 list.add("ifnull(eq_position,'')");
    		}
			if(record.getDivision()!=null&&StrUtil.isNotEmpty(record.getDivision().toString())) {
    			 list.add("ifnull(division,'')");
    		}
			if(record.getDifferMass()!=null&&StrUtil.isNotEmpty(record.getDifferMass().toString())) {
    			 list.add("ifnull(differ_mass,'')");
    		}
			if(record.getStandardWeightCorrected()!=null&&StrUtil.isNotEmpty(record.getStandardWeightCorrected().toString())) {
    			 list.add("ifnull(standard_weight_corrected,'')");
    		}
			if(record.getAirCorrected()!=null&&StrUtil.isNotEmpty(record.getAirCorrected().toString())) {
    			 list.add("ifnull(air_corrected,'')");
    		}
			if(record.getMassCorrected()!=null&&StrUtil.isNotEmpty(record.getMassCorrected().toString())) {
    			 list.add("ifnull(mass_corrected,'')");
    		}
			if(record.getMassTolerance()!=null&&StrUtil.isNotEmpty(record.getMassTolerance().toString())) {
    			 list.add("ifnull(mass_tolerance,'')");
    		}
			if(record.getMagneticReads()!=null&&StrUtil.isNotEmpty(record.getMagneticReads().toString())) {
    			 list.add("ifnull(magnetic_reads,'')");
    		}
			if(record.getMagneticTolerance()!=null&&StrUtil.isNotEmpty(record.getMagneticTolerance().toString())) {
    			 list.add("ifnull(magnetic_tolerance,'')");
    		}
			if(record.getPolarizationReads()!=null&&StrUtil.isNotEmpty(record.getPolarizationReads().toString())) {
    			 list.add("ifnull(polarization_reads,'')");
    		}
			if(record.getPolarizationTolerance()!=null&&StrUtil.isNotEmpty(record.getPolarizationTolerance().toString())) {
    			 list.add("ifnull(polarization_tolerance,'')");
    		}
			if(record.getDeid()!=null&&StrUtil.isNotEmpty(record.getDeid().toString())) {
    			list2.add("'%"+record.getDeid()+"%'");
    		}
			if(record.getNominalMass()!=null&&StrUtil.isNotEmpty(record.getNominalMass().toString())) {
    			list2.add("'%"+record.getNominalMass()+"%'");
    		}
			if(record.getMpe()!=null&&StrUtil.isNotEmpty(record.getMpe().toString())) {
    			list2.add("'%"+record.getMpe()+"%'");
    		}
			if(record.getRead1()!=null&&StrUtil.isNotEmpty(record.getRead1().toString())) {
    			list2.add("'%"+record.getRead1()+"%'");
    		}
			if(record.getRead2()!=null&&StrUtil.isNotEmpty(record.getRead2().toString())) {
    			list2.add("'%"+record.getRead2()+"%'");
    		}
			if(record.getEqPosition()!=null&&StrUtil.isNotEmpty(record.getEqPosition().toString())) {
    			list2.add("'%"+record.getEqPosition()+"%'");
    		}
			if(record.getDivision()!=null&&StrUtil.isNotEmpty(record.getDivision().toString())) {
    			list2.add("'%"+record.getDivision()+"%'");
    		}
			if(record.getDifferMass()!=null&&StrUtil.isNotEmpty(record.getDifferMass().toString())) {
    			list2.add("'%"+record.getDifferMass()+"%'");
    		}
			if(record.getStandardWeightCorrected()!=null&&StrUtil.isNotEmpty(record.getStandardWeightCorrected().toString())) {
    			list2.add("'%"+record.getStandardWeightCorrected()+"%'");
    		}
			if(record.getAirCorrected()!=null&&StrUtil.isNotEmpty(record.getAirCorrected().toString())) {
    			list2.add("'%"+record.getAirCorrected()+"%'");
    		}
			if(record.getMassCorrected()!=null&&StrUtil.isNotEmpty(record.getMassCorrected().toString())) {
    			list2.add("'%"+record.getMassCorrected()+"%'");
    		}
			if(record.getMassTolerance()!=null&&StrUtil.isNotEmpty(record.getMassTolerance().toString())) {
    			list2.add("'%"+record.getMassTolerance()+"%'");
    		}
			if(record.getMagneticReads()!=null&&StrUtil.isNotEmpty(record.getMagneticReads().toString())) {
    			list2.add("'%"+record.getMagneticReads()+"%'");
    		}
			if(record.getMagneticTolerance()!=null&&StrUtil.isNotEmpty(record.getMagneticTolerance().toString())) {
    			list2.add("'%"+record.getMagneticTolerance()+"%'");
    		}
			if(record.getPolarizationReads()!=null&&StrUtil.isNotEmpty(record.getPolarizationReads().toString())) {
    			list2.add("'%"+record.getPolarizationReads()+"%'");
    		}
			if(record.getPolarizationTolerance()!=null&&StrUtil.isNotEmpty(record.getPolarizationTolerance().toString())) {
    			list2.add("'%"+record.getPolarizationTolerance()+"%'");
    		}
        	buffer.append(" CONCAT(");
	        buffer.append(StrUtil.join(",",list));
        	buffer.append(")");
        	buffer.append(" like CONCAT(");
        	buffer.append(StrUtil.join(",",list2));
        	buffer.append(")");
        	if(!" CONCAT() like CONCAT()".equals(buffer.toString())) {
        		addCriterion(buffer.toString());
        	}
        	return (Criteria) this;
        }
        
        public Criteria andLikeQuery2(String searchText) {
		 	List<String> list= new ArrayList<String>();
        	StringBuffer buffer=new StringBuffer();
    		list.add("ifnull(deid,'')");
    		list.add("ifnull(nominal_mass,'')");
    		list.add("ifnull(mpe,'')");
    		list.add("ifnull(read1,'')");
    		list.add("ifnull(read2,'')");
    		list.add("ifnull(eq_position,'')");
    		list.add("ifnull(division,'')");
    		list.add("ifnull(differ_mass,'')");
    		list.add("ifnull(standard_weight_corrected,'')");
    		list.add("ifnull(air_corrected,'')");
    		list.add("ifnull(mass_corrected,'')");
    		list.add("ifnull(mass_tolerance,'')");
    		list.add("ifnull(magnetic_reads,'')");
    		list.add("ifnull(magnetic_tolerance,'')");
    		list.add("ifnull(polarization_reads,'')");
    		list.add("ifnull(polarization_tolerance,'')");
        	buffer.append(" CONCAT(");
	        buffer.append(StrUtil.join(",",list));
        	buffer.append(")");
        	buffer.append("like '%");
        	buffer.append(searchText);
        	buffer.append("%'");
        	addCriterion(buffer.toString());
        	return (Criteria) this;
        }
        
}
	
    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}